J.J. McCarthy's long-awaited NFL debut was a tale of two halves, but it ended in a thrilling 27-24 season-opening victor